alter table UserProfile
add LastModDate         datetime2

go

alter table UserProfile
add CreatedDate         datetime2		not null	

go

alter table MentorMentee
add IsAccepted         bit

INSERT INTO MentorMatchTag( Name, LastModDate, CreatedDate)
VALUES ('Computer Science', getdate(), getdate())
go
INSERT INTO MentorMatchTag( Name, LastModDate, CreatedDate)
VALUES ('Public Policy', getdate(), getdate())
go
INSERT INTO MentorMatchTag( Name, LastModDate, CreatedDate)
VALUES ('Architecture', getdate(), getdate())
go
INSERT INTO MentorMatchTag( Name, LastModDate, CreatedDate)
VALUES ('Electrical Engineering', getdate(), getdate())
go
INSERT INTO MentorMatchTag( Name, LastModDate, CreatedDate)
VALUES ('Law', getdate(), getdate())
go
INSERT INTO MentorMatchTag( Name, LastModDate, CreatedDate)
VALUES ('Business', getdate(), getdate())


go
SET Identity_insert UserType ON
INSERT INTO UserType(UserTypeID,  Name, LastModDate, CreatedDate)
VALUES (1, 'Mentee', getdate(), getdate())
go
INSERT INTO UserType(UserTypeID,  Name, LastModDate, CreatedDate)
VALUES (2, 'Mentor', getdate(), getdate())
SET Identity_insert UserType OFF

go

create table Communication
( 
	CommunicationID	int				identity,
	MenteeID		int, 
	MentorID		int,
	Message	nvarchar(max),
	SenderID        int,
	LastModDate         datetime2,
    CreatedDate         datetime2		not null		
)
go
alter table Communication
   add constraint PK_Communication primary key (CommunicationID)
go
